package com.pengtu.gsj.dao.jsbz;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.pengtu.gsj.dao.hibernate.HibernateDao;
import com.pengtu.gsj.entity.jsbz.RoadMaterial;

@Repository
public class RoadMaterialDao extends HibernateDao<RoadMaterial, String>  {
	
	public List<RoadMaterial> getRoadMatRecYear(String startTime, String endTime) {
		String hql = "select new com.pengtu.gsj.entity.jsbz.RoadMaterial(t.testYear) from RoadMaterial t where t.delFlag='0' and t.testYear <="+endTime+"and t.testYear >="+startTime+" group by t.testYear order by t.testYear asc";
		return find(hql);
	}
}
